<?php

class Create_User_Profile {

	/**
	 * Make changes to the database.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::create('sys_user_profile', function($table)
	    {
		    $table->increments('sup_id');
			$table->date('sup_tarikh_mula');
			$table->date('sup_tarikh_tamat');
			$table->integer('su_id');
			$table->string('sup_id_pengguna');
			$table->string('sup_nama', 200);
			$table->string('sup_emel', 150);
			$table->string('sup_tel', 20);
			$table->string('sup_no_pekerja', 15);
			$table->string('sup_no_ic', 15);
			$table->integer('sukp_no_auto');	
			$table->integer('suj_no_auto');	
			$table->integer('sub_no_auto');	
			$table->integer('suu_no_auto');	
			$table->integer('sup_penyelia_satu');
			$table->integer('sup_penyelia_dua');
			$table->string('sup_tidak_kelihatan');
			$table->integer('sup_is_supervisor');
			$table->date('sup_tarikh_akhir');
			$table->integer('sup_cipta_oleh');	
			$table->timestamps();
			$table->integer('sup_kemaskini_oleh');	
	    });
	}

	/**
	 * Revert the changes to the database.
	 *
	 * @return void
	 */
	public function down()
	{
		Schema::drop('sys_user_profile');
	}

}